<style>
table.summaryTable th,table.summaryTable td{
    border: black 1px solid;
    font-size: 10px;
}

table.summaryTable td{
    font-size: 9px;
    padding: 2px;
    text-align: right;
}

table.summaryTable th{
    text-align: center;
    background: gray;
    color: white;
}

table.summaryTable .jumlahTotal {
    background: gray;
    color: white;
    font-size: 10px;
    font-weight: bold;
}
</style>

   <?php 
   
   $bulan1 = null;
   
        switch ($bulan){
            case null: break;
            case "1": $bulan1 = "Januari"; break;
            case "2": $bulan1 = "Februari"; break;
            case "3": $bulan1 = "Maret"; break;
            case "4": $bulan1 = "April"; break;
            case "5": $bulan1 = "Mei"; break;
            case "6": $bulan1 = "Juni"; break;
            case "7": $bulan1 = "Juli"; break;
            case "8": $bulan1 = "Agustus"; break;
            case "9": $bulan1 = "September"; break;
            case "10": $bulan1 = "Oktober"; break;
            case "11": $bulan1 = "Nopember"; break;
            case "12": $bulan1 = "Desember"; break;
        }
   
   
   if(isset($sales)): ?>
        <div><?php echo $restoran;?></div>
        <div>SUMMARY SALES REPORT SF BULAN <?php echo strtoupper($bulan1);?> TAHUN <?php echo $tahun;?></div>
        <br />
        <table class="summaryTable">
            <tr>
                <th rowspan="2">DAY</th>
                <th rowspan="2">DATE</th>
                <th rowspan="2">FOOD</th>
                <th rowspan="2">BEVERAGE</th>
                
                <?php
                
                    if(strtolower($restoran )== "velpa"){
                        echo '<th>WINE</th>';
                    }
                
                ?>
                                
                <th rowspan="2">TOBACO</th>
                <th rowspan="2">OTHERS</th>
                <th colspan="2">DISCOUNT</th>
                <th rowspan="2">TAX</th>
                <th rowspan="2">SERVICE</th>
                <th rowspan="2">ROUNDING</th>
                <th rowspan="2">TOTAL</th>
                <th rowspan="2">SUBTOTAL</th>
                <th rowspan="2">MONTH TO DATE</th>
            </tr>
            <tr>
                
                <?php
                
                    if(strtolower($restoran ) == "velpa"){
                        echo '<th>TAKE AWAY</th>';
                    }
                
                ?>
                
                <th>CUSTOMER</th>
                <th>ENT/OC</th>
            </tr>
            
            <?php
                
                $beverage = null;
                $food = null;
                $wine_takeaway = null;
                $tobaco = null;
                $others = null;
                $discount_customer = null;
                $discount_ocheck = null;
                $rounding = null;
                $net_sales = null;
                $tax = null;
                $service = null;
                $subtotal = null;
            
            
                $month_to_date = 0; // cumulative subtotal
                foreach($sales as $val):
                    $time = strtotime($val['date']);
                    
                    $food = $food + $val['food'];
                    $beverage = $beverage + $val['beverage'];
                    
                    if(strtolower($restoran )== "velpa"){
                        $wine_takeaway = $wine_takeaway + $val['wine_takeaway'];
                    }
                    
                    $tobaco = $tobaco + $val['tobaco'];
                    $others = $others + $val['others'];
                    $discount_customer = $discount_customer + $val['discount_customer'];
                    $discount_ocheck = $discount_ocheck + $val['discount_ocheck'];
                    $tax = $tax + $val['tax'];
                    $service = $service + $val['service'];
                    $rounding = $rounding + $val['rounding'];
                    $net_sales = $net_sales + $val['net_sales'];
                    $subtotal = $subtotal + $val['subtotal'];
            ?>
            <tr>
                <?php $month_to_date += $val['subtotal'] ?>
                <td><?=date("D",$time)?></td>
                <td><?=date("d/m/Y",$time)?></td>
                <td><?=number_format($val['food'],0,',','.')?></td>
                <td><?=number_format($val['beverage'],0,',','.')?></td>
                
                <?php
                
                    if(strtolower($restoran ) == "velpa"){
                        echo '<td>'.number_format($val['wine_takeaway'],0,',','.').'</td>';
                    }
                
                ?>
                
                <td><?=number_format($val['tobaco'],0,',','.')?></td>
                <td><?=number_format($val['others'],0,',','.')?></td>
                <td><?=number_format($val['discount_customer'],0,',','.')?></td>
                <td><?=number_format($val['discount_ocheck'],0,',','.')?></td>
                <!-- <td><?=number_format($val['discount'],0,',','.')?></td> -->
                <td><?=number_format($val['tax'],0,',','.')?></td>
                <td><?=number_format($val['service'],0,',','.')?></td>
                <td><?=number_format($val['rounding'],0,',','.')?></td>
                <td><?=number_format($val['net_sales'],0,',','.')?></td>
                <td><?=number_format($val['subtotal'],0,',','.')?></td>
                <td><?=number_format($month_to_date,0,',','.')?></td>
            </tr>
            <?php 
                endforeach;
                
                $colspan = '14';
                
                if(strtolower($restoran ) == "velpa"){
                    $colspan = '15';
                }
            ?>
            <tr>
                <td colspan="<?php echo $colspan;?>"></td>
            </tr>
            <tr>
                <td colspan="<?php echo $colspan;?>"></td>
            </tr>
            
            <tr>
                <td class="jumlahTotal" colspan="2">TOTAL</td>
                <td class="jumlahTotal"><?php echo number_format($food,0,',','.');?></td>
                <td class="jumlahTotal"><?php echo number_format($beverage,0,',','.');?></td>
                
                <?php
                
                    if(strtolower($restoran ) == "velpa"){
                        echo '<td class="jumlahTotal">'.number_format($wine_takeaway,0,',','.').'</td>';
                    }
                
                ?>
                <td class="jumlahTotal"><?php echo number_format($tobaco,0,',','.');?></td>
                <td class="jumlahTotal"><?php echo number_format($others,0,',','.');?></td>
                <td class="jumlahTotal"><?php echo number_format($discount_customer,0,',','.');?></td>
                <td class="jumlahTotal"><?php echo number_format($discount_ocheck,0,',','.');?></td>
                <td class="jumlahTotal"><?php echo number_format($tax,0,',','.');?></td>
                <td class="jumlahTotal"><?php echo number_format($service,0,',','.');?></td>
                <td class="jumlahTotal"><?php echo number_format($rounding,0,',','.');?></td>
                <td class="jumlahTotal"><?php echo number_format($net_sales,0,',','.');?></td>
                <td class="jumlahTotal"><?php echo number_format($subtotal,0,',','.');?></td>
                <td class="jumlahTotal"><?php echo number_format($month_to_date,0,',','.');?></td>
            </tr>
        </table>
        <?php endif; ?>
        
        <?php if(isset($payment)): ?>
        <div>SF PAYMENT BULAN <?php echo $bulan1;?> TAHUN <?php echo $tahun;?></div>
        <br />
        <table class="summaryTable">
            <tr>
                <th rowspan="2">DATE</th>
                <th>SALES</th>
                <th colspan="4">SALES CARD</th>
                <th rowspan="2">CL</th>
                <th rowspan="2">VOUCHER</th>
                <th rowspan="2">TOTAL</th>
                <th rowspan="2">MONTH TO DATE</th>
            </tr>
            <tr>
                <th>CASH</th>
                <th>VISA</th>
                <th>MASTER</th>
                <th>BCA CARD</th>
                <th>DEBIT</th>
            </tr>
            <?php
            
            $cash = null;
            $visa = null;
            $master = null;
            $bca_card = null;
            $debit = null;
            $city_ledger = null;
            $voucher = null;
            $total = null;
            
            $month_to_date = 0; // cumulative subtotal
            foreach($payment as $val):
            
            $cash = $cash + $val['cash'];
            $visa = $visa + $val['visa'];
            $master = $master + $val['master'];
            $bca_card = $bca_card + $val['bca_card'];
            $debit = $debit + $val['debit'];
            $city_ledger = $city_ledger + $val['city_ledger'];
            $voucher = $voucher + $val['voucher'];
            $total = $total + $val['total'];
            ?>
            <tr>
                <?php $month_to_date += $val['total'] ?>
                <td><?=date("d/m/Y",strtotime($val['date']))?></td>
                <td><?=number_format($val['cash'],0,',','.')?></td>
                <td><?=number_format($val['visa'],0,',','.')?></td>
                <td><?=number_format($val['master'],0,',','.')?></td>
                <td><?=number_format($val['bca_card'],0,',','.')?></td>
                <td><?=number_format($val['debit'],0,',','.')?></td>
                <td><?=number_format($val['city_ledger'],0,',','.')?></td>
                <td><?=number_format($val['voucher'],0,',','.')?></td>
                <td><?=number_format($val['total'],0,',','.')?></td>
                <td><?=number_format($month_to_date,0,',','.')?></td>
            </tr>
            <?php endforeach; ?>
            
            <tr>
                <td colspan="10"></td>
            </tr>
            <tr>
                <td colspan="10"></td>
            </tr>
            
            <tr>
                <td class="jumlahTotal" colspan="1">TOTAL</td>
                <td class="jumlahTotal"><?php echo number_format($cash,0,',','.');?></td>
                <td class="jumlahTotal"><?php echo number_format($visa,0,',','.');?></td>
                <td class="jumlahTotal"><?php echo number_format($master,0,',','.');?></td>
                <td class="jumlahTotal"><?php echo number_format($bca_card,0,',','.');?></td>
                <td class="jumlahTotal"><?php echo number_format($debit,0,',','.');?></td>
                <td class="jumlahTotal"><?php echo number_format($city_ledger,0,',','.');?></td>
                <td class="jumlahTotal"><?php echo number_format($voucher,0,',','.');?></td>
                <td class="jumlahTotal"><?php echo number_format($total,0,',','.');?></td>
                <td class="jumlahTotal"><?php echo number_format($month_to_date,0,',','.');?></td>
            </tr>
            
        </table>
        <?php endif; ?>